package com.hqyj.dao;

import com.hqyj.pojo.SysWarehouse;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

public interface SysWarehouseMapper {
    int deleteByPrimaryKey(Integer wId);

    int insert(SysWarehouse record);

    int insertSelective(SysWarehouse record);

    SysWarehouse selectByPrimaryKey(Integer wId);

    int updateByPrimaryKeySelective(SysWarehouse record);

    int updateByPrimaryKey(SysWarehouse record);

    //查询仓库食材列表
    List<SysWarehouse> selectList(SysWarehouse warehouse);

    // 查询是否含有特定的食材
    String selectMaterial(String name);

    //根据食材名查询食材数目
    int selectNumberBymaterial(String name);

    //更新食材数目
    int updateNumber(SysWarehouse warehouse);

    //查询所有食材
    List<SysWarehouse> selectAllMaterial();

    //退货的数目

    int returnNumber(SysWarehouse warehouse);


}